Tabela PhStItem

Definicja tabeli PhStItem

Name

PhStItem

Code

PhStItem

Comment

Asortyment magazynów


Lista kolumn tabeli PhStItem

Name

Code

StItemID

StItemID

ResourceID

ResourceID

PackID

PackID

StItemKindID

StItemKindID

Description

Description

Avaliable

Avaliable

Name

Name

StartDT

StartDT

StopDT

StopDT

Active

Active

DirectorateApprovalForOrder

DirectorateApprovalForOrder

PatientRequiredForOrder

PatientRequiredForOrder

Imported

Imported

OldSystemID

OldSystemID

HeadOfTheWardApprovalForOrder

HeadOfTheWardApprovalForOrder

ExternalLink

ExternalLink


Kolumna StItemID tabeli PhStItem

Definicja kolumny StItemID tabeli PhStItem

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID asortymentu magazynu


Kolumna ResourceID tabeli PhStItem

Definicja kolumny ResourceID tabeli PhStItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PackID tabeli PhStItem

Definicja kolumny PackID tabeli PhStItem

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StItemKindID tabeli PhStItem

Definicja kolumny StItemKindID tabeli PhStItem

Name

StItemKindID

Code

StItemKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Description tabeli PhStItem

Definicja kolumny Description tabeli PhStItem

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis


Kolumna Avaliable tabeli PhStItem

Definicja kolumny Avaliable tabeli PhStItem

Name

Avaliable

Code

Avaliable

Data Type

NUMBER(3)

Mandatory

No

Comment

Asortyment dostepny


Kolumna Name tabeli PhStItem

Definicja kolumny Name tabeli PhStItem

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa


Kolumna StartDT tabeli PhStItem

Definicja kolumny StartDT tabeli PhStItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania/okresu


Kolumna StopDT tabeli PhStItem

Definicja kolumny StopDT tabeli PhStItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania/okresu


Kolumna Active tabeli PhStItem

Definicja kolumny Active tabeli PhStItem

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga aktywnosci w systemie


Kolumna DirectorateApprovalForOrder tabeli PhStItem

Definicja kolumny DirectorateApprovalForOrder tabeli PhStItem

Name

DirectorateApprovalForOrder

Code

DirectorateApprovalForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga zatwierdzenia dyrekcji przy zamówieniu


Kolumna PatientRequiredForOrder tabeli PhStItem

Definicja kolumny PatientRequiredForOrder tabeli PhStItem

Name

PatientRequiredForOrder

Code

PatientRequiredForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga pacjenta przy zamówieniu


Kolumna Imported tabeli PhStItem

Definicja kolumny Imported tabeli PhStItem

Name

Imported

Code

Imported

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Lek pochodzi z importu docelowego


Kolumna OldSystemID tabeli PhStItem

Definicja kolumny OldSystemID tabeli PhStItem

Name

OldSystemID

Code

OldSystemID

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Identyfikatory ze starego systemu


Kolumna HeadOfTheWardApprovalForOrder tabeli PhStItem

Definicja kolumny HeadOfTheWardApprovalForOrder tabeli PhStItem

Name

HeadOfTheWardApprovalForOrder

Code

HeadOfTheWardApprovalForOrder

Data Type

NUMBER(3)

Mandatory

No

Comment

Lek wymaga zgody ordynatora przy zamawianiu


Kolumna ExternalLink tabeli PhStItem

Definicja kolumny ExternalLink tabeli PhStItem

Name

ExternalLink

Code

ExternalLink

Data Type

VARCHAR2(255)

Mandatory

No

Comment

do zapisu linku do zewnetrznej charakterystyki leku


Lista kluczy tabeli PhStItem

Name

Code

Primary

Key_2

Key_2

X


Klucz Key_2 tabeli PhStItem

Definicja klucza Key_2 tabeli PhStItem

Name

Key_2

Code

Key_2

Primary

Yes

Comment